<!DOCTYPE html>
<?php
include('config.php');
require_once('classes/class.jira.php');
include("classes/connect.php");
ini_set('display_errors', 'Off');

if(isset($_GET["vcode"])){
	$vcode=$_GET["vcode"];	
}
else{
	echo '<meta http-equiv="refresh" content="0.1;url=index.php">';
}
?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Applicant Details</title>
 <link rel="stylesheet" href="css/header.css" type="text/css" media="all">           
            <!--<link rel="stylesheet" href="css/layout.css" type="text/css" media="all">-->
            
        <link href="reports/examples/content/shared/styles/examples-offline.css" rel="stylesheet">
        <link href="reports/examples/content/shared/styles/kendo.common.min.css" rel="stylesheet">
        <link href="reports/examples/content/shared/styles/kendo.rtl.min.css" rel="stylesheet">
        <link href="reports/examples/content/shared/styles/kendo.default.min.css" rel="stylesheet">

        <script src="reports/js/jquery.min.js"></script>
        <script src="reports/js/kendo.web.min.js"></script>
        <script src="reports/js/console.js"></script>
            
        <link href="reports/js/kendo.dataviz.min.js" rel="stylesheet">        
        <link href="css/demo.css" rel="stylesheet" type="text/css" />
         
    <!--<script type="text/javascript" src="js/calendarDateInput.js"></script>-->
<!--<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.js"></script>-->
<!--<script type="text/javascript" src="js/jquery.timePicker.js"></script>-->
<script src="chosen/chosen.jquery.js" type="text/javascript"></script>
</head>
<body class="sonata-bc">
          
<?
$sql1="SELECT * from trn_emaildetails where vcode='".$vcode."'";
$rs1 =mysql_query($sql1);
$row = mysql_fetch_array($rs1);
?>  

     
   <div class="navbar navbar-fixed-top">
        <div class="navbar-inner">
            <div class="container-fluid header-bar-container">
                <div class="header-bar-top">
                    <a class="brand">
                        <img src="images/logo_white.png" alt="JiraPortal">Recruitment Application      
                    </a>
                </div>
            </div>

            <div class="container-fluid">
                <a class="btn btn-navbar" data-target=".nav-collapse" data-toggle="collapse">
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                </a>
                <div class="nav-collapse">
                    <ul class="nav" id="menu" style="background-color: #1C2326">
                        <li >
                            <a><?=$row['applicantName']?></a>
                        </li>
                 
            </div>
        </div>

        </div>
    </div>
   <div class="homecontainer">
  
	<div class="task" style="position: absolute;width: 50%; left: 25%;">  
    <div id="example" class="k-content">
     <div class="span11">
                        <h2 style="text-align: center;"><?=$row['applicantName']?></h2>
                     
                       <fieldset style="width: 96%;">  
                                <legend>Personal Details</legend>
                                <div class="appdetailbox">
                                    <div class="appdetail">First Name</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['fname']?></div>
                                </div>
                               <div class="appdetailbox">
                                    <div class="appdetail">Last Name</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['lname']?></div>
                                </div>                  
                                                          
                                 <div class="appdetailbox">
                                    <div class="appdetail">Address 1</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['address1']?></div>
                                </div>          
                                <div class="appdetailbox">
                                    <div class="appdetail">Address 2</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['address2']?></div>
                                </div>
                                <div class="appdetailbox">
                                    <div class="appdetail">Date of Birth</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['birthday']?></div>
                                </div> 
                                <div class="appdetailbox">
                                    <div class="appdetail">City</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['city']?></div>
                                </div>                                 
                                
                            </fieldset>                           
                         <fieldset style="width: 96%;">  
                                <legend>Qualification</legend>
                                <div class="appdetailbox">
                                    <div class="appdetail">School</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['school']?></div>
                                </div>
                                 <div class="appdetailbox">
                                    <div class="appdetail">Institute(University/School)</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['highschool']?></div>
                                </div>
                                <div class="appdetailbox">
                                    <div class="appdetail">Highest Professional Qualification</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['highprofessional']?></div>
                                </div>                  
                               
                            </fieldset> 
                        	<?
			$sql2="SELECT * from trn_projectexperience where mainid='".$row['id']."'";
			$rs2 =mysql_query($sql2);
			if(mysql_num_rows($rs2)>0){
			?>
                        <fieldset>  
                                <legend>Hands on Experience</legend>
                                <?
                                    $i=1;
                                    while($row1 = mysql_fetch_array($rs2)){

                                    ?>
                                 <div class="appdetailbox">
                                    <div class="appdetail">Project/Work Experience <?echo $i?></div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row1['experince']?></div>
                                </div> 
                        <?$i++;}}?>
                        </fieldset>
                          <fieldset style="width: 96%;">  
                                <legend>Technical Skills</legend>
                                <div class="appdetailbox">
                                    <div class="appdetail">Technologies Known</div>
                                    <div class="appseperator">:</div><div class="appinfo">
                                    <?
                                        $sql3="SELECT * from trn_technologyskills where mainid='".$row['id']."'";
                                        $rs3 =mysql_query($sql3);
                                        while($row2 = mysql_fetch_array($rs3)){
                                        $sql4="SELECT * from sys_technicalskills where id='".$row2['techid']."'";
                                        $rs4 =mysql_query($sql4);
                                        $row3 = mysql_fetch_array($rs4);
                                        ?>
                                        <?=$row3['skillname']?> <b><?=$row2['ratevalue']?>/10</b> &nbsp;&nbsp;
                                    <?}?>
                                </div></div>
                               
                            </fieldset> 
                        <?
			$sqlquery="SELECT * from trn_workexperience where mainid='".$row['id']."'";
			$result=mysql_query($sqlquery);
			if(mysql_num_rows($result)>0){			
			?>
                            <fieldset style="width: 96%;">  
                                <legend>Working Experience</legend>
                            
                            <?
                            $sql5="SELECT * from trn_workexperience where mainid='".$row['id']."' AND currentplace = '1'";
                            $rs5 =mysql_query($sql5);
                            while($row4 = mysql_fetch_array($rs5)){
                            ?>	
                                			
							<div class="appworkwrapper">
							<div class="appworkdetailbox"> 
								<div class="appdetail">Current Workplace</div>
							</div>
								<div class="appworkdetails"> 
									<div class="appworkdesig">Designation</div><div class="appseperator">:</div>
									<div class="appworkinfo"><?=$row4['designation']?></div>
								</div>
								<div class="appworkdetails"> 
									<div class="appworkdesig">Company</div><div class="appseperator">:</div>
									<div class="appworkinfo"><?=$row4['companyname']?></div>
								</div>
								<div class="appworkdetails"> 
									<div class="appworkdesig">Join Date</div><div class="appseperator">:</div>
									<div class="appworkinfo"><?=$row4['joineddate']?></div>
								</div>
							</div>
			<?
			}
			$sql6="SELECT * from trn_workexperience where mainid='".$row['id']."' AND currentplace = '0'";
			$rs6 =mysql_query($sql6);
			while($row5 = mysql_fetch_array($rs6)){
			?>
							<div class="appworkwrapper">
							<div class="appworkdetailbox"> 
								<div class="appdetail">Previous Workplace</div>
							</div>
								<div class="appworkdetails"> 
									<div class="appworkdesig">Designation</div><div class="appseperator">:</div>
									<div class="appworkinfo"><?=$row5['designation']?></div>
								</div>
								<div class="appworkdetails"> 
									<div class="appworkdesig">Company</div><div class="appseperator">:</div>
									<div class="appworkinfo"><?=$row5['companyname']?></div>
								</div>
								<div class="appworkdetails"> 
									<div class="appworkdesig">Join Date</div><div class="appseperator">:</div>
									<div class="appworkinfo"><?=$row5['joineddate']?></div>
								</div>
							</div>
                        <?}}?>				
                        </fieldset>
                         <fieldset style="width: 96%;">  
                                <legend>Joining EYEPAX</legend>
                                <div class="appdetailbox">
                                    <div class="appdetail">Current Salary</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['currentSalary']?></div>
                                </div>
                                <div class="appdetailbox">
                                    <div class="appdetail">Expected Salary</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['expectedsalary']?></div>
                                </div>
                                <div class="appdetailbox">
                                    <div class="appdetail">How soon can you join</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['howsoon']?></div>
                                </div>
                                 <div class="appdetailbox">
                                    <div class="appdetail">Why we should hire you</div>
                                    <div class="appseperator">:</div>
                                    <div class="appinfo"><?=$row['whyhire']?></div>
                                </div>
                            </fieldset> 
                    </div>
                      
</div>
</div>
</div>
	<style>
	.appdetailbox
	{
		width:95%;
	}
	.appinfo{
		float:none;
		margin-left: 238px;
    position: relative;
    width:auto;
	}
	.appworkwrapper {
    height: 161px;
    width: auto;
}
	</style>
</body>
</html>